*********************************** * * * STOCK TRACKING SYSTEM VERSION 2 * * * *********************************** The STOCK TRACKING SYSTEM VERSION 2 is SHAREWARE. If you find the Stock Tracking System useful, please send a check for $25.00 to; Eric King 305 Easy St. #16 Mountain View, Ca. 94043 The programs that make up this system are expressly Copyright 1986/ 1987 by Eric P. King CIS PPN 72255,213 These programs incorporate portions of The Toolbox Series , a copyrighted product of Roger Wagner Publishing, Inc. CHAPTER 1 -- GETTING STARTED: **** Complete steps 1 - 3s if you have the PRODOS version of CHART & GRAPH Toolbox from Roger Wagner Publishing, Inc. Until that time, just skip them and do not try to use the graphing functions. 1) Create a subdirectory named DHR on /STKTRK. 2) Copy the following files from side 2 of the Chart & Graph Toolbox disk to /STKTRK/DHR /AC2/DHR/AMPERCHART /AC2/DHR/ROUTINES /AC2/DHR/RELOCATE.TB 3) The printer routines will only support the Apple Imagewriter or the Epson MX/FX series printers. The system is set up for an Imagewriter with a Super Serial card in slot 1. If your configuration is different you must complete the following: a) Boot a disk with PRODOS & BASIC.SYSTEM, get into basic. b) Place the Chart & Graph Toolbox in a drive with side 1 up. c) Type PREFIX/AC1/DUMP d) Type RUN CONFIGURE e) make the selections. When the ] prompt appears; f) Type PREFIX/AC1 g) Type -WORKBENCH and then place /STKTRK in another drive. h) select 0 (exit) i) Type LOAD/STKTRK/GRAPHER j) Type CALL 2051 k) select 2 (delete a command) l) select the # for command IWD m) select 1 (add a command) n) the toolbox name is DUMP/xxxxxxxx where xxxxxxx is DHR.IMAGE.TB, DHR.MX.80.TB, or DHR.MX.100.TB as appropriate for your printer. o) the command name is IWD p) press RETURN to get back to the menu q) select 0 (exit) r) Type SAVE/STKTRK/GRAPHER s) turn off the computer to ensure that the WORKBENCH is wiped from memory **Whewwwwwww! Now down to business. FIRST BOOTUP: For 5 1/4" systems; Do a cold start with /STKTRK in the boot drive For 3.5" drives; if the 3.5 is not the boot drive, turn on the computer, press CONTROL and RESET at the same time, then type PR#x where x is the slot # for your 3.5" controller. For Hard Disks; get PRODOS & BASIC SYSTEM up & running. Type PREFIX/vol/STKTRK. Type RUN STARTUP The screen will clear and you will be shown the current prefix. If you want to store your data on the program disk simply answer Yes to the prompt. This is recommended for 3.5" & hard disks, and is the only option if all you have is a single 5 1/4" drive. If you have two 5 1/4" drives and you have prepared a data disk as described above, place the data disk in the other drive and answer No to the prompt. You will then be prompted for the Volume name and any subdirectory paths you wish to use. STARTUP now creates a text file and stores this info for use by the other programs, and then runs STOCKTRK. You will never go through this prompting again unless you delete the file CONFIG. STOCKTRK checks for the Master file under the data Prefix, and not finding it this first time, creates several files and a subdirectory that it needs. Now you are requested to add an investment. There must be at least one investment on file before you can leave this module and proceed to other things, so we will start here. CHAPTER 2 -- ADD AN INVESTMENT A name may consist of up to six characters, and the first character MUST be a letter. I STRONGLY recommend that you use the stocks' correct ticker symbol, which is seldom the same as the newspaper listing. If you will NEVER use the auto update feature then don't worry about this. Because of the way ProDos works, spaces in a ticker are not allowed. Some tickers, especially options, have spaces between letters. You must substitute a . (period) for the space when you name the investment. For now enter IBM and press return. You will be told that this is IBM Lot# 1. If this was the second purchase (or short) of IBM, the cue would say IBM Lot# 2, etc. Pressing return again takes you to the data entry screen. Select #1 and enter your data. If you make a mistake, select #1 again and make the corrections needed. When you are satisfied with the way things look, select #2 and the transaction will be recorded. The B or S for (B)uy/(S)hort sale is required. The Alert price field is for your convenience and is not required. ++ CONVENTIONS ++ The following conventions are standard on all data screens: #OF SHARES, PRICES, COMMISSIONS: decimal only, no fractions i.e.; enter 121.75, not 121 3/4 MONTH/DAY: one or two digits, no alphanumerics YEAR: two digits, no alphanumerics VOLUME: enter in either 100's or 1000's. Just be consistent. If a price file for this ticker already exists a new one will not be created. This allows you to sell all lots of a ticker and buy it back at a later date without having to completely reconstruct the pricing data for it. CHAPTER 3 -- UPDATE MARKET PRICES There are three options here. 1) Update Market Prices 2) Integrate Compuserve Data 3) Return to Main Menu We will cover Manual updating first. MANUAL: After you enter the name of the stock you are updating and the program verifies that it is valid, it will go out and read the price file for the date of the last update. If the price file for this stock is empty the date of the last update will be set to NONE until you record an update. The data screen prompts for High, Low, Close, Volume, and date. Volume is the only optional field. Your investment style will determine whether you make daily or weekly entries. The program doesn't care. If you are going to use the auto update feature, then you should enter daily data. For charting purposes a weekly price file is one created by this program from the daily data file, which will be the High, low, cumulative volume, and closing price for the week. If you are not going to use auto updating and you do want to chart weekly data, get it from a newspaper and select the daily file for charting. I realize that the use of the terms daily & weekly may be a tad confusing the way that I have used them. The file that the program considers the 'daily' file can be whatever frequency that you make it. It can be a daily, weekly, monthly, or even yearly price file. It just depends on what you put into it. The 'weekly' price file, in program terms, is created and updated by the program from the data that you have entered into the 'daily' file. The program uses five data sets from the 'daily' file for each one set placed into the 'weekly' file. AUTO UPDATING: or (Integrate Compuserve Data). The advantage is that you can have CIS create a text file of pricing data for you to download that the Stock Tracking System will use to do your price file updating for you. Also, if you are going to regularly update the same stocks, you can create a file in your personal file area that lists them and will save you from having to type in the same ticker symbols every time you wish to do an update. Another use is in checking out the movement of a stock that you are interested in. Use ADD AN INVESTMENT to put it in the portfolio with a cost of 0, then download and integrate a years' (or whatever) worth of data for charting in a few minutes rather than a couple of hours worth of manual price entry. OKAY, how do we do this? Log on to CIS and GO MQUOTEII. At the prompt enter MQDATA prompt INTERFACE DESIRED: enter 1 for prices prompt OUTPUT TO TTY OR FILENAME: enter PRICE.DAT prompt ENTER SECURITIES ONE PER LINE: enter one ticker per line for each that you want, or enter @filename if you have created a file listing your securities (we'll get to that) prompt (D)AILY,(W)EEKLY,(M)ONTHLY: enter D prompt STARTING DATE: enter a date, or enter return so that you can simply specify a number of days to retrieve. prompt ENDING DATE: enter a date, or a simple RETURN to use the newest date on file. prompt ENTER OPTIONS ONE PER LINE: enter a return prompt ENTER ITEMS DESIRED: enter 1,2,3,4,5 (exactly like that) The data is now stored in the file PRICE.DAT Press return to get back to the MQUOTEII prompt. Enter FILTRN you are now in the CIS File transfer program. Go ahead and download PRICE.DAT to your computer. Log off of CIS and copy the file to your data disk and rename it to CIS.DATA Boot up /STKTRK and select 1) Update Market Prices from the menu. Select 2) Integrate Compuserve Data. After confirming that you do indeed wish to do this, the integrator module will be run and will update your price files. Now I know that this all seems like a lot of work, but once you have done it a couple of times you'll breeze right through it. + NOTE + the auto update feature will not insert data into a price file that is older than the most recent update in that file. About your file of ticker symbols. Lets go back to where we are at the MQUOTEII prompt. Enter FILGE. For a filename, tell it TICKER.DAT prompt FILE READY: enter each ticker on a separate line like this; IBM FDFFX AT EVTRX E EI /EX the /EX tells the program that you are done and to store the file. The next time that you go into MQDATA and come to prompt ENTER SECURITIES ONE PER LINE: enter @TICKER.DAT and the tickers in that file will be used CHAPTER 4 -- RECORD DIVIDEND/ CAPITOL GAIN This module lets you keep a record of dividends paid to you and capitol gains distributions from mutual funds and other investments. No rate of return is computed. This feature is provided as a record keeping convenience. The data entry is simple and self explanatory. CHAPTER 5 -- SELL AN INVESTMENT This routine is used to record sales from the portfolio, and the closing out of short positions. You can close out part or all of an investment. If you do not sell (or buy) all the shares for a lot#, an adjustment is made to the Master file to reflect the change, and the sale is recorded. If you do completely close out a position, that lot# is removed from the Master file, and if more than one purchase (short) of that stock is on file the remaining lot# 's are adjusted. This keeps your portfolio current and also provides a record of gains & losses for year-end. Chapter 6 -- EDIT A RECORD This routine gives you the ability to make corrections to the MASTER, SALES, PRICE, DIVIDEND, and CAPITOL GAINS files if you discover an error. For the MASTER and PRICE selections you will be asked for the ticker name first. The other selections skip that step. The file will be checked for the number of entries and you will be asked which one you wish to edit. The rest of the procedure is exactly the same as if you were making the entry for the first time. Chapter 7 -- FILE MAINTENANCE You are presented with 9 options. 1) Clean up a Price File 2) Delete an Investment 3) Delete a Price File 4) Create Weekly Price File 5) Adjust for Stock Split 6) Create New Sales File 7) Create New Dividend File 8) Create New Cap.Gain file 9) Return to Main Menu Option 1) Clean Up a Price File, is for reducing the size of overly large price files. If you have more than 220 entries in the price file you can either select how many of the newest entries to keep, or to keep the most recent 220. GRAPHER can only use the most recent 220 entries in a file. Any time a Price file grows to over 20 Blocks in size it has more than 220 entries. The routine will insist that you retain at least the 5 most recent entries in the file. + NOTE + if you download a block of daily data from CIS so that you can create a good historical weekly file, do not use this option on the daily file until your weekly file is created. Options 2 & 3 allow you to delete a single investment or a price file respectively. + NOTE + deleting an investment does not delete the associated price file. This is a deliberate restriction in case you have more than one lot# of an investment on file, or if you anticipate a future purchase of the same investment. Option 4) Create Weekly Price File, is provided to create a weekly price file from a daily file and to update an existing weekly file from updated daily data. To create a weekly file there must be at least 5 entries in the daily file. To update a weekly file, there must be at least 5 daily entries newer than the most recent weekly entry. + NOTE + This option is the only method to update a STOCKTRK created weekly file, and these files are used only for charting. There is no provision for editing weekly files. Weekly price files may be identified in a catalog by the suffix .W attached to the ticker name. You can delete such files without affecting existing investments. Option 5) Adjust for Stock Split, will adjust the Master and Price files to compensate for a split or reverse split of an investment. You will be asked for the investment name, then for the split ratio. The module will then perform the adjustments to the files. This module will not adjust the Sales, Dividend, or the Capitol Gains file. Options 6) Create New Sales File 7) Create New Dividend File 8) Create New Cap.Gain file Are year - end type functions and all three work the same. If you are very sure that you will no longer need to obtain printed reports of the data stored in these files, these options will delete the existing file and initialize a new one. Chapter 8 -- REPORTS Three types of reports are available providing the data is on file to create them. CURRENT GAIN/LOSS will show you what your positions cost you and per share cost, their current total market value and per share value, $ GN/LS, APR (annualized percentage rate of return), TYPE of position, and your target price. This report uses 2 lines per investment, with the second line showing the purchase and current per share value. The last line of the report shows you the total cost, total $ Gn/Ls, and the raw % Gn/Ls of your portfolio. DIVIDEND/ CAP GAIN Report will report the Dividend and Capitol Gain data on file. SALES GAIN/ LOSS will report your gains and losses on each sale recorded, as well as the APR attained and overall % Gn/Ls. This report uses 2 lines per sale, with the second line showing the purchase and sales commission. The only tricky item on the menu is #1. By selecting 1 repeatedly, the option will cycle through REPORT to SCREEN, REPORT to PRINTER, and REPORT to DISK FILE. Each time you select #1, the screen will cycle and #1 will show the current destination for the report. This selection must be made before the type of report is chosen. ** //c users ** The module assumes that your printer is connected to port #1. If your printer is connected to port 2, you must modify line # xxxx in REPORTER. Change PRINT D$"PR#1" to PRINT D$"PR#2". Chapter 9 -- GRAPHICS This option is available only if you have the Chart & Graph Toolbox and have gone through the installation procedures in GETTING STARTED. Selecting it without having done the above will bomb the program (no harm done) and require you to re- boot. Graphics will chart the daily or weekly price/ volume data for a stock in double HIRES graphics. After the chart is displayed, you can look at it at your leisure. Pressing RETURN will take you to an options menu. Only two of them need an explanation. Option 2) Add an Average, allows you to select a range of 9 to 50 and will plot this average on the existing chart and display it to you. You may select this option as many times as you like (can you still see the chart?). Option 3) Print the Chart, will only work with supported printers and only prints the chart in 1 size. //////////////////////////////////////////////////////////////// ++++++++++ NOTE ++++++++++ While all attempts have been made to provide a bug free product, the beta testers and I may not have caught everything. There could also be future enhancements to the system. Enhancement & fix files will be uploaded with the file names STKPG2.Fx (where x will be a sequential number). An occasional check of the DL will show you these files. Do this by typing S STKPG2.F* after you get to the DL. When you find one of these files, down load it as a TEXT file and copy it to a copy of the Stock Tracking System disk. Boot up the Stock Tracking System and press Control - Reset. You are now in Basic. Type EXEC STKPG2.Fx and press return. The file will load the modules to be modified, perform the modifications, and save the modules, all without any intervention on your part. The only hitch that could occur is if some noise got into the file during downloading. If there are any SYNTAX ERRORS or hangups, use a word processor to check the text file and clean it up, then try again. As users contribute tips and hints on using the Stock Tracking System, I will compile them and upload them to the DL. The file name convention will be STKPG2.NTx where x is the sequential file number. These will be text files.